SELECT events.*, eventToShluchaAndDate.* FROM events
LEFT JOIN eventToShluchaAndDate ON events.eventID = eventToShluchaAndDate.eventToShluchEventID
WHERE events.mercazAllId=103 AND eventID=14273
AND eventToShluchFromTime != '00:00:00' AND eventToShluchToTime != '00:00:00'